﻿CREATE TABLE [dbo].[InventoryItems] (
    [InventoryItemID] INT           IDENTITY (1, 1) NOT NULL,
    [itemTypeID]      SMALLINT      NOT NULL,
    [baseUPC]         NVARCHAR (50) NULL,
    [itemShortDesc]   NVARCHAR (50) NOT NULL,
    [itemLongDesc]    TEXT          NULL,
    [dateAdded]       DATETIME      NOT NULL,
    [userAddedID]     INT           NOT NULL,
    [isDeleted]       BIT           NOT NULL
);



